SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001497s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031608 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031608 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (832156,287617,866417,320898,87518,765044,168721,1045606,180235,228863,898675,774821,126506,484977,747779,980973,363655,717833,148850,186026,133047,490415,293762,254051,522962,203359,817371,176660,502481,390640,453747,968662,515674,314360,965082,233029,531684,781952,265198,275436,789156,978355,674800,490338,1018504,727090,685259,969882,995276,276321,232204,969494,390373,886960,788601,663288,510103,740800,904272,195954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]