SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014413 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014413 [ RunTime:0.001497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (656264,914288,533418,906638,167631,320300,1015298,319927,11122,560480,584237,133386,996126,942555,660387,278102,545440,348251,507278,32367,161605,693406,88777,392252,949434,399004,63259,979452,937207,402772,714589,848516,518501,298267,496339,951162,905634,972503,492494,458028,459422,6546,555785,446231,480869,65572,752388,230298,664400,347244,95606,400887,982183,196167,866221,476064,56715,702634,918224,546967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]