SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001734s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458836 LIMIT 1 [ RunTime:0.000512s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458836 [ RunTime:0.001953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528846,342604,963801,396053,663224,928540,305727,1016475,551415,933289,785017,270744,879728,659699,1010180,780059,360765,509356,985814,904208,801479,1043166,875164,72407,951755,253157,1027582,543207,588106,207476,515228,384427,945563,246511,657587,991834,798250,101488,80245,570592,130782,350443,558487,206725,1025927,966059,826053,983314,102610,297842,829529,348362,256487,420763,448820,455731,638055,55899,116595,820375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]