SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300947 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300947 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418751,565610,289069,903073,809578,64565,151194,761121,867085,584522,936046,248810,291746,539172,26060,606793,418095,178363,39144,209781,146031,26001,292185,322317,79882,139789,223479,742804,309829,817419,918457,691710,906378,438737,729478,384747,281191,10810,551288,794323,459862,987642,963750,827139,100358,300185,166590,226891,81469,367012,2888,999646,946257,521665,168791,502053,977751,543250,926658,242779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300947 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300947 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]