SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002000s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302019 LIMIT 1 [ RunTime:0.001172s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302019 [ RunTime:0.006852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (378003,987026,608890,24169,777944,1022167,688385,458204,804623,982314,1026339,657645,584950,668737,50387,877476,567705,630557,19565,221341,849835,608399,37041,259047,310748,179965,475258,513534,825414,498633,285365,159651,844512,398793,563813,592502,133453,338952,43121,248503,747814,760563,812133,802547,122459,321198,307167,851873,1046389,293064,861177,718892,264438,115657,869289,853068,219191,507674,503936,553107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006891s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]