SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31399 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31399 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144908,231638,225227,403883,973770,1027579,377242,586364,394956,158510,1034810,1019899,980323,397565,781146,497841,382780,1037158,129252,511202,632841,1029869,350516,200629,527528,571528,873039,562147,551727,233569,636078,508516,249618,702308,111177,346560,85384,710380,246713,110149,42963,1033658,198469,221970,591897,932700,495277,93043,298782,358395,774659,846197,93962,924248,135830,253030,846503,443299,631370,968663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001765s ]