SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533428 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533428 [ RunTime:0.001872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003653,607115,524776,832615,531127,258163,188194,214450,593966,105403,249335,745344,309692,182184,404381,731146,743686,239829,562346,632911,685242,620518,604723,553722,273736,680532,148843,269576,879198,650908,1039064,83551,228203,993845,310050,77065,60652,731622,246350,825108,778727,984489,691399,694236,760536,203156,295855,242959,942740,706254,1005050,58169,166446,520715,420637,609881,883182,771373,383197,690048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]