SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426039 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426039 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614246,756181,182294,196545,393843,308190,347405,623243,65344,303825,599006,895337,955610,427357,818988,812270,484463,73565,173678,542800,980798,653963,480401,757266,293540,238043,242891,458453,480325,959318,383202,689654,144347,874559,987596,945263,109648,47721,328231,203103,361172,518314,98362,656113,170842,1257,516163,495955,882021,294327,213223,869399,183830,632076,600242,519488,593197,664057,813535,1027540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]