SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475633 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475633 [ RunTime:0.002586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048555,34762,52751,52590,409942,609697,318429,1018112,245581,502595,994533,264136,399531,620523,671523,1048314,188789,465407,705154,323407,234363,432578,654433,247860,98171,923,145115,627716,1017561,954931,382630,1007996,872654,406730,915332,898740,1018788,106242,163629,781105,270283,577496,368332,546926,261551,806397,140271,916706,835488,828819,817953,575233,234687,403179,823323,728751,265586,150528,415052,568451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475633 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475633 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000754s ]