SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504986 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504986 [ RunTime:0.002021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (225347,640884,511394,336107,942965,253797,87075,141984,688587,407504,666457,294116,537545,203022,845081,714979,394786,926891,85987,497015,787617,706677,648907,67522,65262,531763,645050,305269,306303,579331,514109,500847,558890,477060,666637,339336,97555,13360,426430,248621,53698,965764,694772,842339,470228,842752,985561,330968,148266,317421,51351,312631,810452,359671,794066,860177,977986,979896,287983,247505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]